package com.lpf.mappers;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.lpf.entity.Users;

public interface UsersMapper {

    @Select("select * from users")
    List<Users> getSelectUser();

    @Update("UPDATE users set name=#{name},age=#{age} where id=#{id}")
    void getUpdateUser(Users user);

    @Insert("insert into users(name,age) values(#{name},#{age});")
    void getInsertUser(Users user);

    @Delete("DELETE FROM users where id=#{id}")
    void getDeleteUser(@Param("") int id);

}